[sql.xlat2 DP4_database_name ]

This section is used by the DP4 SQL Engine to translate table and column names submitted to it into the correct DP4 name. The format is as follows:

[sql.xlat2 DP4_database_name]
oemname=dp4name

Where oemname is a name submitted to the SQL Engine and dp4name is the corresponding name on the DP4 database.

In principle, this section should not be required. Correctly written software would submit correct SQL to the DP4 SQL Engine, using the table and column names the DP4 engine would report to the catalog functions. However it has been known for third party software to make invalid assumptions about table and field names, causing it to submit an incorrect name.

A second, and more valid reason for requiring this section is that you may have a previously written SQL statement for a database which was originally a non DP4 database, but for which you have now created a DP4 database. The DP4 database may have to have changed some of the names from the original database. If this section contains the translation from the original name to the name on the new DP4 database the SQL Engine will accept a statement that uses the original name, thus saving you from having to update it for the DP4 database. In this case the AUXWINST program will probably have created the appropriate entries for you automatically.